﻿CREATE TABLE [dbo].[ExpenseItems] (
    [Id]              UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [ExpenseId]       UNIQUEIDENTIFIER NULL,
    [ItemDescription] NVARCHAR (550)   NULL,
    [AccountCode]     NVARCHAR (50)    NULL,
    [ProjectId]       UNIQUEIDENTIFIER NULL,
    [BudgetLineId]    UNIQUEIDENTIFIER NULL,
    [ItemCurrencyId]  UNIQUEIDENTIFIER NULL,
    [ItemAmount]      MONEY            NULL,
    [ExchangeRateId]  UNIQUEIDENTIFIER NULL,
    [ConvertedAmount] MONEY            NULL
);

